---add by zhouyq begin 2010-11-05

 --workflow_data_source
set IDENTITY_INSERT [workflow_data_source] ON
insert into workflow_data_source (ID, NAME, JDBC_CLASS, JDBC_URL, JDBC_USER_NAME, JDBC_PASSWORD, CREATE_ID, UPDATE_ID, DESCN, CREATE_TIME, UPDATE_TIME, STATUS)
values (1, 'k3db', 'net.sourceforge.jtds.jdbc.Driver', 'jdbc:jtds:sqlserver://localhost:1433;DatabaseName=AIS20090410141516', 'sa', 'sa', 2, null, 'a', cast('2010-10-18 14:01:04' as datetime), null, 1);
set IDENTITY_INSERT [workflow_data_source] OFF

--WORKFLOW_FLOWTYPE
set IDENTITY_INSERT [WORKFLOW_FLOWTYPE] ON
Insert into WORKFLOW_FLOWTYPE (ID, NAME, CATALOGY, DEPT_ID, USER_ID, POS, RED_STYLE, CREATEDATE, LASTDATE, FILENO_NAME, FILENO_FORMAT, FILENO_START, FILENO_WIDTH, FILENO_AUTO)
Values (140, '费用报销申请单', '财务类', 2, 2, 2, 2, cast('2010-09-28 00:00:00' as datetime), cast('2010-09-29 00:00:00' as datetime), 'FILENO', '@文件编号@', 1, '000', 0);
insert into workflow_flowtype (ID, NAME, PATH, CATALOGY, DEPT_ID, USER_ID, POS, RED_STYLE, CREATEDATE, LASTDATE, DETAILFIELD, DETAILFIELDTYPE, DETAILFIELDOPINIONS, DETAILFILESIGNS, DETAILMUSTINPUT, DESCN, FILENO_NAME, FILENO_STRING, FILENO_FORMAT, FILENO_START, FILENO_WIDTH, FILENO_AUTO)
values (280, '费用(借款)申请', '', '财务类', 2, 2, 1, 2, cast('2010-09-28' as datetime), cast('2010-09-29' as datetime), '', '', '', '', '', '费用(借款)申请', 'FILENO', '', '@文件编号@', 1, '000', 0);
set IDENTITY_INSERT [WORKFLOW_FLOWTYPE] OFF

--WORKFLOW_FLOWFIELD
set IDENTITY_INSERT [WORKFLOW_FLOWFIELD] ON
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (242, '填写日期', 140, 'field', 'dat', 3, 1, 'text', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (251, '领导审批', 140, 'long', 'str', 3, 1, 'text', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (256, '领款日期', 140, 'field', 'dat', 13, 1, 'text', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (301, '发生日期', 140, 'list', 'dat', 3, 1, 'text', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (240, '报销人', 140, 'field', 'str', 1, 1, 'integratio', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (245, '单据及附件', 140, 'field', 'int', 6, 1, 'text', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (248, '币别', 140, 'field', 'str', 9, 1, 'integratio', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (253, '复核', 140, 'field', 'str', 10, 1, 'text', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (246, '合计', 140, 'field', 'flo', 7, 1, 'text', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (249, '备注', 140, 'long', 'str', 1, 1, 'text', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (254, '出纳', 140, 'field', 'str', 11, 1, 'text', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (255, '领款人', 140, 'field', 'str', 12, 1, 'text', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, EXPRESSION, ISQUERY)
Values (247, '大写', 140, 'field', 'str', 8, 1, 'amount', 'fieldstr7', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (241, '报销部门', 140, 'field', 'str', 2, 1, 'integratio', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (250, '部门审批', 140, 'long', 'str', 2, 1, 'text', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (252, '财务主管', 140, 'long', 'str', 4, 1, 'text', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (257, '用途', 140, 'list', 'str', 1, 1, 'text', 0);
Insert into WORKFLOW_FLOWFIELD (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, STATUS, INPUTTYPE, ISQUERY)
Values (258, '金额', 140, 'list', 'str', 2, 1, 'text', 0);
insert into workflow_flowfield (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, WIDTH, POINT, STATUS, FORMAT, VALUESCALE, VALUEDEFAULT, INPUTTYPE, INPUTFROM, EXPRESSION, CANNULL, ISQUERY, ISLIST, DESCN)
values (285, '借款分类', 280, 'field', 'str', 6, null, null, 1, '', '', '', 'text', '', '', null, 0, null, '借款分类');
insert into workflow_flowfield (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, WIDTH, POINT, STATUS, FORMAT, VALUESCALE, VALUEDEFAULT, INPUTTYPE, INPUTFROM, EXPRESSION, CANNULL, ISQUERY, ISLIST, DESCN)
values (284, '币别', 280, 'field', 'str', 5, null, null, 1, '', '', '', 'integratio', '', '', null, 0, null, '币别');
insert into workflow_flowfield (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, WIDTH, POINT, STATUS, FORMAT, VALUESCALE, VALUEDEFAULT, INPUTTYPE, INPUTFROM, EXPRESSION, CANNULL, ISQUERY, ISLIST, DESCN)
values (286, '预计还款日期', 280, 'field', 'dat', 7, null, null, 1, '', '', '', 'text', '', '', null, 0, null, '预计还款日期');
insert into workflow_flowfield (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, WIDTH, POINT, STATUS, FORMAT, VALUESCALE, VALUEDEFAULT, INPUTTYPE, INPUTFROM, EXPRESSION, CANNULL, ISQUERY, ISLIST, DESCN)
values (287, '申请金额', 280, 'field', 'flo', 8, null, null, 1, '', '', '', 'text', '', '', null, 0, null, '申请金额 小写');
insert into workflow_flowfield (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, WIDTH, POINT, STATUS, FORMAT, VALUESCALE, VALUEDEFAULT, INPUTTYPE, INPUTFROM, EXPRESSION, CANNULL, ISQUERY, ISLIST, DESCN)
values (291, '财务主管审批', 280, 'long', 'str', 3, null, null, 1, '', '', '', 'text', '', '', null, 0, null, '财务主管审批');
insert into workflow_flowfield (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, WIDTH, POINT, STATUS, FORMAT, VALUESCALE, VALUEDEFAULT, INPUTTYPE, INPUTFROM, EXPRESSION, CANNULL, ISQUERY, ISLIST, DESCN)
values (293, '支付方式', 280, 'field', 'str', 11, null, null, 1, '', '', '', 'integratio', '', '', null, 0, null, '');
insert into workflow_flowfield (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, WIDTH, POINT, STATUS, FORMAT, VALUESCALE, VALUEDEFAULT, INPUTTYPE, INPUTFROM, EXPRESSION, CANNULL, ISQUERY, ISLIST, DESCN)
values (295, '出纳', 280, 'field', 'str', 13, null, null, 1, '', '', '', 'text', '', '', null, 0, null, '出纳');
insert into workflow_flowfield (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, WIDTH, POINT, STATUS, FORMAT, VALUESCALE, VALUEDEFAULT, INPUTTYPE, INPUTFROM, EXPRESSION, CANNULL, ISQUERY, ISLIST, DESCN)
values (281, '申请日期', 280, 'field', 'dat', 2, null, null, 1, '', '', '', 'text', '', '', null, 0, null, '');
insert into workflow_flowfield (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, WIDTH, POINT, STATUS, FORMAT, VALUESCALE, VALUEDEFAULT, INPUTTYPE, INPUTFROM, EXPRESSION, CANNULL, ISQUERY, ISLIST, DESCN)
values (282, '借款人', 280, 'field', 'str', 3, null, null, 1, '', '', '', 'integratio', '', '', null, 0, null, '借款人');
insert into workflow_flowfield (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, WIDTH, POINT, STATUS, FORMAT, VALUESCALE, VALUEDEFAULT, INPUTTYPE, INPUTFROM, EXPRESSION, CANNULL, ISQUERY, ISLIST, DESCN)
values (283, '借款部门', 280, 'field', 'str', 4, null, null, 1, '', '', '', 'integratio', '', '', null, 0, null, '借款部门');
insert into workflow_flowfield (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, WIDTH, POINT, STATUS, FORMAT, VALUESCALE, VALUEDEFAULT, INPUTTYPE, INPUTFROM, EXPRESSION, CANNULL, ISQUERY, ISLIST, DESCN)
values (288, '大写', 280, 'field', 'str', 9, null, null, 1, '', '', '', 'amount', '', 'fieldstr8', null, 0, null, '申请金额 大写');
insert into workflow_flowfield (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, WIDTH, POINT, STATUS, FORMAT, VALUESCALE, VALUEDEFAULT, INPUTTYPE, INPUTFROM, EXPRESSION, CANNULL, ISQUERY, ISLIST, DESCN)
values (289, '事由及用途', 280, 'long', 'str', 1, null, null, 1, '', '', '', 'text', '', '', null, 0, null, '事由及用途');
insert into workflow_flowfield (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, WIDTH, POINT, STATUS, FORMAT, VALUESCALE, VALUEDEFAULT, INPUTTYPE, INPUTFROM, EXPRESSION, CANNULL, ISQUERY, ISLIST, DESCN)
values (290, '部门经理审批', 280, 'long', 'str', 2, null, null, 1, '', '', '', 'text', '', '', null, 0, null, '部门经理审批');
insert into workflow_flowfield (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, WIDTH, POINT, STATUS, FORMAT, VALUESCALE, VALUEDEFAULT, INPUTTYPE, INPUTFROM, EXPRESSION, CANNULL, ISQUERY, ISLIST, DESCN)
values (292, '费用支付类型', 280, 'field', 'str', 10, null, null, 1, '', '', '', 'text', '', '', null, 0, null, '费用支付类型');
insert into workflow_flowfield (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, WIDTH, POINT, STATUS, FORMAT, VALUESCALE, VALUEDEFAULT, INPUTTYPE, INPUTFROM, EXPRESSION, CANNULL, ISQUERY, ISLIST, DESCN)
values (294, '实付金额', 280, 'field', 'flo', 12, null, null, 1, '', '', '', 'calculate', '', '@fieldstr8@', null, 0, null, '实付金额');
insert into workflow_flowfield (ID, NAME, FLOWTYPE_ID, FIELDTYPE, DATATYPE, FIELDSERIAL, WIDTH, POINT, STATUS, FORMAT, VALUESCALE, VALUEDEFAULT, INPUTTYPE, INPUTFROM, EXPRESSION, CANNULL, ISQUERY, ISLIST, DESCN)
values (296, '付款日期', 280, 'field', 'dat', 14, null, null, 1, '', '', '', 'text', '', '', null, 0, null, '付款日期');
set IDENTITY_INSERT [WORKFLOW_FLOWFIELD] OFF

--WORKFLOW_INTEGRATION_TEMP
set IDENTITY_INSERT [WORKFLOW_INTEGRATION_TEMP] ON
Insert into WORKFLOW_INTEGRATION_TEMP (ID, NAME, CONDITION, LIST_DETAIL, SQL_DETAIL, DISPLAY_MODE, CREATE_ID, CREATE_TIME, UPDATE_ID, UPDATE_TIME, STATUS, INTEGRATION_TYPE_ID, DATA_SOURCE_ID)
Values (87, '支付方式', '@fname|名称@', '@fname|名称@', 'SELECT * FROM t_Settle', '2', 2, cast('2010-09-20 17:43:29' as datetime), 2, cast('2010-09-29 16:16:03' as datetime), 1, 1, 1);
Insert into WORKFLOW_INTEGRATION_TEMP (ID, NAME, CONDITION, LIST_DETAIL, SQL_DETAIL, DISPLAY_MODE, CREATE_ID, CREATE_TIME, UPDATE_ID, UPDATE_TIME, STATUS, INTEGRATION_TYPE_ID, DATA_SOURCE_ID)
Values (84, '费用支付类型', '@fname|方式名称@', '@fname|方式名称@,@fitemid|id@,@ftype|类型@', 'SELECT * FROM t_RP_SystemEnum t where t.FType = 14', '2', 2, cast('2010-09-20 15:57:33' as datetime), 2, cast('2010-10-08 15:55:38' as datetime), 1, 1, 1);
Insert into WORKFLOW_INTEGRATION_TEMP (ID, NAME, CONDITION, LIST_DETAIL, SQL_DETAIL, DISPLAY_MODE, CREATE_ID, CREATE_TIME, UPDATE_ID, UPDATE_TIME, STATUS, INTEGRATION_TYPE_ID, DATA_SOURCE_ID)
Values (122, '申请部门', '@Fname|部门名称@', '@Fname|部门名称@,@Fnumber|部门代码@', 'SELECT * FROM t_Department', '2', 2, cast('2010-10-15 18:14:24' as datetime), 2, cast('2010-10-15 18:16:27' as datetime), 1, 3, 1);
Insert into WORKFLOW_INTEGRATION_TEMP (ID, NAME, CONDITION, LIST_DETAIL, SQL_DETAIL, DISPLAY_MODE, CREATE_ID, CREATE_TIME, UPDATE_ID, UPDATE_TIME, STATUS, INTEGRATION_TYPE_ID, DATA_SOURCE_ID)
Values (121, '申请人', '@FName|名称@', '@FName|名称@,@FNumber|代码@', 'select * from t_Emp', '2', 2, cast('2010-10-15 18:12:55' as datetime), 2, cast('2010-10-15 18:16:35' as datetime), 1, 3, 1);
Insert into WORKFLOW_INTEGRATION_TEMP (ID, NAME, LIST_DETAIL, SQL_DETAIL, DISPLAY_MODE, CREATE_ID, CREATE_TIME, STATUS, INTEGRATION_TYPE_ID, DATA_SOURCE_ID)
Values (101, '币别选择', '@FCurrencyID|ID@,@FNumber|编号@,@FName|名称@,@FExchangeRate|汇率@,@UUID|UUID@', 'SELECT t.FCurrencyID,t.FNumber,t.FName,t.FExchangeRate,t.UUID FROM t_Currency t', '2', 2, cast('2010-09-28 17:14:03' as datetime), 1, 1, 1);
insert into workflow_integration_temp (ID, NAME, CONDITION, LIST_DETAIL, SQL_DETAIL, DISPLAY_MODE, DESCN, CREATE_ID, CREATE_TIME, UPDATE_ID, UPDATE_TIME, STATUS, INTEGRATION_TYPE_ID, DATA_SOURCE_ID)
values (61, '币别', '', '@FNumber|币别代码@,@FName|币别@', 'select * from  t_Currency', '2', '', 4, cast('2010-10-14 17:47:44' as datetime), null, null, 1, 1, 1);
insert into workflow_integration_temp (ID, NAME, CONDITION, LIST_DETAIL, SQL_DETAIL, DISPLAY_MODE, DESCN, CREATE_ID, CREATE_TIME, UPDATE_ID, UPDATE_TIME, STATUS, INTEGRATION_TYPE_ID, DATA_SOURCE_ID)
values (62, '借款支付方式', '', '@FNumber|支付方式代码@,@FName|支付方式@', 'select * from t_Settle', '2', '', 4, cast('2010-10-14 17:51:24' as datetime), 4, cast('2010-10-14 17:58:11' as datetime), 1, 1, 1);
insert into workflow_integration_temp (ID, NAME, CONDITION, LIST_DETAIL, SQL_DETAIL, DISPLAY_MODE, DESCN, CREATE_ID, CREATE_TIME, UPDATE_ID, UPDATE_TIME, STATUS, INTEGRATION_TYPE_ID, DATA_SOURCE_ID)
values (81, '申请借款部门', '', '@FItemID|部门ID@,@FNumber|部门号@,@FName|部门名称@', 'SELECT * FROM t_Department', '2', '', 4, cast('2010-10-15 17:37:09' as datetime), null, null, 1, 1, 1);
insert into workflow_integration_temp (ID, NAME, CONDITION, LIST_DETAIL, SQL_DETAIL, DISPLAY_MODE, DESCN, CREATE_ID, CREATE_TIME, UPDATE_ID, UPDATE_TIME, STATUS, INTEGRATION_TYPE_ID, DATA_SOURCE_ID)
values (82, '申请借款人', '', '@FItemID|申请人ID@,@FNumber|申请人编号@,@FName|申请人名称@', 'select e.* from t_Emp e', '2', '', 4, cast('2010-10-15 17:39:57' as datetime), 4, cast('2010-10-15 17:53:58' as datetime), 1, 1, 1);
set IDENTITY_INSERT [WORKFLOW_INTEGRATION_TEMP] OFF

--WORKFLOW_INTEGRATION
set IDENTITY_INSERT [workflow_integration] ON
insert into workflow_integration (ID, CONDITION, LIST_DETAIL, SQL_DETAIL, DISPLAY_MODE, FORM_FIELD, WORKFLOW_FLOWFIELD_ID, WORKFLOW_DATA_SOURCE_ID, WORKFLOW_INTEGRATION_TEMP_ID)
values (81, '', '@FItemID|申请人ID@,@FNumber|申请人编号@,@FName|申请人名称@', 'select e.* from t_Emp e', '2', '@FName|借款人@', 282, 1, 82);
insert into workflow_integration (ID, CONDITION, LIST_DETAIL, SQL_DETAIL, DISPLAY_MODE, FORM_FIELD, WORKFLOW_FLOWFIELD_ID, WORKFLOW_DATA_SOURCE_ID, WORKFLOW_INTEGRATION_TEMP_ID)
values (61, '', '@FNumber|币别代码@,@FName|币别@', 'select * from  t_Currency', '2', '@FName|币别@', 284, 1, 61);
insert into workflow_integration (ID, CONDITION, LIST_DETAIL, SQL_DETAIL, DISPLAY_MODE, FORM_FIELD, WORKFLOW_FLOWFIELD_ID, WORKFLOW_DATA_SOURCE_ID, WORKFLOW_INTEGRATION_TEMP_ID)
values (62, '', '@FNumber|支付方式代码@,@FName|支付方式@', 'select * from t_Settle', '2', '@fname|支付方式@', 293, 1, 62);
insert into workflow_integration (ID, CONDITION, LIST_DETAIL, SQL_DETAIL, DISPLAY_MODE, FORM_FIELD, WORKFLOW_FLOWFIELD_ID, WORKFLOW_DATA_SOURCE_ID, WORKFLOW_INTEGRATION_TEMP_ID)
values (82, '', '@FItemID|部门ID@,@FNumber|部门号@,@FName|部门名称@', 'SELECT * FROM t_Department', '2', '@FName|借款部门@', 283, 1, 81);
Insert into WORKFLOW_INTEGRATION (ID, CONDITION, LIST_DETAIL, SQL_DETAIL, DISPLAY_MODE, FORM_FIELD, WORKFLOW_FLOWFIELD_ID, WORKFLOW_DATA_SOURCE_ID, WORKFLOW_INTEGRATION_TEMP_ID)
Values (161, '@FName|名称@', '@FName|名称@,@FNumber|代码@', 'select * from t_Emp', '2', '@Fname|报销人@', 240, 1, 121);
Insert into WORKFLOW_INTEGRATION (ID, LIST_DETAIL, SQL_DETAIL, DISPLAY_MODE, FORM_FIELD, WORKFLOW_FLOWFIELD_ID, WORKFLOW_DATA_SOURCE_ID, WORKFLOW_INTEGRATION_TEMP_ID)
Values (102, '@FNumber|编号@,@FName|名称@,@FExchangeRate|汇率@', 'SELECT t.FCurrencyID,t.FNumber,t.FName,t.FExchangeRate,t.UUID FROM t_Currency t', '2', '@FnaMe|币别@', 248, 1, 101);
Insert into WORKFLOW_INTEGRATION (ID, CONDITION, LIST_DETAIL, SQL_DETAIL, DISPLAY_MODE, FORM_FIELD, WORKFLOW_FLOWFIELD_ID, WORKFLOW_DATA_SOURCE_ID, WORKFLOW_INTEGRATION_TEMP_ID)
Values (162, '@Fname|部门名称@', '@Fname|部门名称@,@Fnumber|部门代码@', 'SELECT * FROM t_Department', '2', '@Fname|报销部门@', 241, 1, 122);
set IDENTITY_INSERT [workflow_integration] OFF
 --- add by zhouyq end 2010-11-05